SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
Run Time: 0.001683
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using index condition |
SELECT thread.*
,
NULL AS thread_read_date,
node.node_id AS forum_id, node.title AS forum_title
FROM xf_thread AS thread
INNER JOIN xf_node AS node ON
(node.node_id = thread.node_id)
INNER JOIN xf_forum AS forum ON
(forum.node_id = thread.node_id)
WHERE (1=1) AND (thread.node_id IN (186, 42, 75, 382, 9, 10, 12, 13, 14, 286, 50, 51, 199, 91, 117, 243, 242, 281, 381, 375, 153, 282, 370, 371, 376, 377, 378, 379, 380, 56, 384, 385, 324, 4, 15, 76, 263, 227, 228, 229, 230, 46, 357, 89, 18, 21, 239, 25, 148, 152, 17, 169, 28, 147, 72, 73, 23, 94, 32, 41, 194, 195, 196, 208, 133, 101, 123, 30, 74, 237, 280, 29, 40, 78, 22, 43, 37, 45, 86, 70, 126, 128, 19, 177, 48, 146, 181, 182, 20, 24, 183, 330, 170, 176, 223, 224, 226, 187, 225, 291, 288, 171, 172, 175, 173, 284, 193, 53, 155, 99, 100, 93)) AND (thread.post_date > 1713587473) AND ((thread.discussion_type != 'redirect' AND thread.discussion_state != 'deleted' AND thread.discussion_state != 'moderated'))
ORDER BY thread.view_count DESC
LIMIT 10
Run Time: 0.002797
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | node_id_last_post_date,node_id_sticky_state_last_post,post_date | post_date | 4 | | 1 | Using index condition; Using where; Using filesort |
SIMPLE | forum | eq_ref | PRIMARY | PRIMARY | 4 | xf.thread.node_id | 1 | Using index |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | xf.thread.node_id | 1 | |
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , VietXfAdvStats_ControllerPublic_AdvStats, ThreadsHot, valid, , 1716179473,
Run Time: 0.005531